USE [ybc5bai]
GO
drop procedure throwexception
/****** Object:  StoredProcedure [dbo].[throwexception]    Script Date: 10/11/2017 11:14:37 ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER OFF
GO


/****** Object:  Stored Procedure dbo.throwexception    Script Date: 2013-8-26 10:50:47 ******/

/****** Object:  Stored Procedure dbo.throwexception    Script Date: 2013-2-20 9:01:38 ******/


/***********************************************************************************************
author: awens
last updated: 2004-07-19, awens
remark:
***********************************************************************************************/
CREATE procedure [dbo].[throwexception] 
  @name nvarchar(2000)
as
begin
 declare
   @msg nvarchar(2000)
  create table #table(             
             Name nVarChar(2000),  
             msg nvarchar(2000)
	      )
set @msg = @name	      
set insert into #table values(@name,@msg)	 
select * from #table 
  
drop table #table

end


GO


